3c72c49aec83649cfa01adec93eb937d7950c9fe,yamj3-core/src/main/java/org/yamj/core/database/dao/ApiDao.java,ApiDao,getSqlArtwork,#OptionsIndexArtwork#,1342
Before Change
sqlScalars.addToSql("ag.id AS generatedId,");
sqlScalars.addToSql("a.season_id AS seasonId,");
sqlScalars.addToSql("a.series_id AS seriesId,");
sqlScalars.addToSql("a.videodata_id AS videodataId,");
sqlScalars.addToSql("a.artwork_type AS artworkType,");
sqlScalars.addToSql("ag.cache_filename AS cacheFilename,");
sqlScalars.addToSql("ag.cache_dir AS cacheDir");
sqlScalars.addToSql("FROM artwork a");
sqlScalars.addToSql(SQL_LEFT_JOIN_ARTWORK_LOCATED);
sqlScalars.addToSql(SQL_LEFT_JOIN_ARTWORK_GENERATED);
After Change
sqlScalars.addToSql("FROM artwork a");
sqlScalars.addToSql(SQL_LEFT_JOIN_ARTWORK_LOCATED);
sqlScalars.addToSql(SQL_LEFT_JOIN_ARTWORK_GENERATED);
sqlScalars.addToSql("WHERE 1=1");
if (options.getId() > 0L) {
sqlScalars.addToSql("AND a.id=:id");